EMT Practice Test

1. Question Content...

---

Question1: How can a report author ensure that a report changes automatically when rotating a mobile device between Landscape and Portrait views?

Question2: A company has a Product Returns report. The Return Comments query item is present in the list query but was left out of the list due to space constraints on the report page. The users have asked to see this information interactively.
How could the report author add this functionality with only minimal changes to the existing report?

Question3: A report author needs to create an Active Report and consider how connections, variables and interactive behaviors using data controls will be handled in the template.
How will these be handled?

Question4: A report author needs the label in a List column title to be dynamic.
How can this be implemented with a dynamic value?

Question5: A report author renders an Active Report as an TML file on the local computer.
Where are the Charts Created?

Question6: An Active Report contains a data deck with the following values on multi select controls:

How many cards would be generated?

Question7: A report needs to modify the Interactive Behavior within an Active Report.
Which button can be used?

Question8: A customer wants to report the product types with the largest average revenue. In addition, the total revenue should be shown and all product types with revenue less than three percent (>3%) in a single bar.
Targeting this result:

How can this be done?

Question9: A report author has to create a Crosstab report with Region and Product data in the rows of the Crosstab. The Crosstab can be created in two different ways as shown below.

Which Crosstab/Crosstabs is/are discontinuous Crosstab/Crosstabs?

Question10: A report author has the following filter in a report:
[Product line] in ?pline?
The report author adds a Value prompt based on the existing parameter 'pline'. After adding the prompt, the Auto-submit property is defaulted to 'No' and cannot be changed to 'Yes'.
What is the cause of this?

Question11: A company would like to implement their own corporate style across all reports using a single Report as a reference. A requirement is to display the year of the data selected in the report in the header. The year is not being resolved correctly as shown below:

How can the problem with this report be resolved?

Question12: A customer has a bar chart in a report that displays a steady increase in revenue by product line over time. The requirement is to graphically illustrate this progression in the data series without significantly the report.
How can this be done?

Question13: A report author wants to display the report name on the report page.
Which type of calculation should be used?

Question14: A report author has created a report as shown below:

What has been defined during the building of this report?

Question15: A company would like to distribute reports to users via an email address or a directory entry.
How should the burst table be defined for this to work appropriately?

Question16: Which properties must be set when using a SQL object?

Question17: A report author wants to nest a chart within a list and filter the chart data to relate to the row of the list that it is displayed in.
How can this be done?

Question18: Which file type can be uploaded in Cognos Analytics?

Question19: A report author needs to create filters in Cognos Analytics - Reporting.
What arte the three different types of filtering?

Question20: What does a developer need to know in order to expose Cognos Analytics Dashboards for mobile consumption?

Question21: A report author has added a Button Bar control to an Active Report that allows users to view data for different regions. The report author now wants to make it possible for users to filter the report on multiple regions at once.
What should the report author do?

Question22: A report author is building a report intended for an iPad on the Cognos Mobile App. the report consists of two Charts that need to be side by side when the tablet is landscape and on top of each other when the tablet is landscape and on top of each other when the tablet is portrait.
What technique should be used to accomplish this?

Question23: A report author is going to develop a report and wants to ensure that the layout if defined correctly.
What should be done first?

Question24: A report author created the following list report and wants to filter all order methods which generated total revenue less than one billion.

Which filter should be used?

Question25: How can an Uploaded file be combined with data from a database?

Question26: A user is creating a join relationship in a Data module.
What benefit can be expected from setting a filter join?

Question27: What happens when a report is run with full interactivity?

Question28: The HR department has requested the report author to change the formatting of a report. The fact cells of the crosstab need to have a different font color.
How can this be done?

Question29: A report author wants to filter a report on two data items, and has decided to use a combined filter rather than two custom filters.
Why has the report author decided to use a combined filter?

Question30: A customer wants to have a report with a bar chart, which is going to be displayed on a tablet. By changing a filter on the report, the chart should change dynamically. The report output size should be as small as possible.
How can this be achieved?

Question31: A report author has created a Dashboard visualization and needs to filter it on a data item that is not displayed.
How can this be accomplished?

Question32: A report author uploads files into Cognos Analytics - Reporting.
Which file formats are supported? (Choose two.)

Question33: What is the maximum number of objects within an Active Report designed for mobile use?

Question34: A report author wants to add calculations that were created in the published package to a report.
Where can this be done?

Question35: Which statement is true when a report author wants to optimize reports for mobile users?